CREATE TABLE daycare.ChildNotes
  (
   ChildNoteId INT NOT NULL
                   IDENTITY(1,1)
                   PRIMARY KEY
 , TimeStamp DATETIME2 NOT NULL
 , ChildId INT NOT NULL
 , NotedById INT NOT NULL
 , NoteText VARCHAR(1000) NOT NULL
  )
ALTER TABLE daycare.ChildNotes ADD CONSTRAINT DF_ChildNotes_TimeStamp DEFAULT GETDATE() FOR TimeStamp
ALTER TABLE daycare.ChildNotes ADD CONSTRAINT FK_ChildNotes_Children FOREIGN KEY(ChildId) REFERENCES daycare.Children(ChildId)
ALTER TABLE daycare.ChildNotes ADD CONSTRAINT FK_ChildNotes_Employees FOREIGN KEY(NotedById) REFERENCES daycare.Employees(EmployeeId)
GO